Huế

Nhắc đến Huế người ta thường nghĩ ngay đến các cung điện, đền đài mang hơi thở cổ xưa một thời vua chúa huy hoàng. Ai cũng muốn một lần du lịch Huế để tận mắt nhìn thấy những bằng chứng sinh động của triều đại phong kiến cuối cùng. Không chỉ thế, nét dịu dàng thư thái và cuộc sống chậm rãi nơi đây cũng được nhiều người yêu thích.

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour'	0.0023579597473145
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00061702728271484
3	SELECT region_id,title,slug,country_id FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no asc	0.0016489028930664
4	SELECT distinct country_id FROM default_region where region_id=14 LIMIT 0,1	0.00016689300537109
5	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='14' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0018420219421387
6	SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1	0.00016403198242188
7	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='5' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0017678737640381
8	SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1	0.00015997886657715
9	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='6' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0018489360809326
10	SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1	0.00015711784362793
11	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='7' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0014450550079346
12	SELECT continent_id,title,slug FROM default_continent WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc	0.0013129711151123
13	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='3' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.001392126083374
14	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='4' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.001244068145752
15	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='5' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0012218952178955
16	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='6' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0011661052703857
17	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='7' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0011579990386963
18	SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=477 order by order_no asc	0.0010490417480469
19	SELECT servicecat_id,title,slug,intro,image FROM default_servicecat WHERE lang_id='vn' and is_trash=0 and is_online=1 and servicecat_id IN (7,8,9,10)	0.001244068145752
20	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='cruise' and act_page='cat' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00061607360839844
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019598007202148
22	SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.001248836517334
23	SELECT tour_property_id FROM default_tour_property WHERE lang_id='vn' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3	0.0012660026550293
24	SELECT distinct short FROM default_property where property_id=950 LIMIT 0,1	0.00018405914306641
25	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00065803527832031
26	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00015711784362793
27	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='tour' and act_page='tour_departure_point' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00052309036254883
28	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001370906829834
29	SELECT city_id,title,banner,intro,content FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and slug='hue' LIMIT 0,1	0.001288890838623
30	SELECT guidecat_idintro,title,image FROM default_guidecat WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc	0.00095415115356445
31	SELECT guide_id,slug,title,publish_date FROM default_guide WHERE lang_id='vn' and is_trash=0 and is_online=1 and cat_id='' and country_id='4' and city_id='654' order by order_no asc	0.0014839172363281
32	SELECT region_id,title FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' order by order_no asc	0.0010900497436523
33	SELECT tourcat_id,title FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc	0.0010359287261963
34	SELECT tour_id FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='654')	0.0012531280517578
35	SELECT tour_id,departure_point_id,slug,title,image,duration_type,duration_custom,number_day,number_night,list_tag_id FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='654') order by order_no asc LIMIT 0,15	0.001370906829834
36	SELECT max(number_day) as max,min(number_day) as min FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1	0.0010519027709961
37	SELECT max(min_price) as max,min(min_price) as min FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1	0.0010719299316406
38	SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0011031627655029
39	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='page' and act_page='about' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00052309036254883
40	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00011205673217773

Huế

a-z tourism destinations in Việt Nam

Mekong

Miền Bắc

Miền Trung

Miền Nam

Về chúng tôi

Kiểu du lịch

Khác

Theo dõi

Kênh thanh toán